--SELECT * FROM ResumeCertificate
--DELETE FROM ResumeCertificate
--INSERT INTO srv_lnk.nchr2008.dbo.ResumeCertificate
SELECT top 5
Convert(int,right(id,7))  AS [ID],Convert(int,right(resumeid,7))  AS [ResumeID],[DateQualified] AS [GotYear],[CertificationName] AS [CertName],NULL AS [OtherInfo],[Score] AS [Results],'Chinese' AS [strLanguage],0 AS [Flag],Convert(int,right(resumeid,7)) AS [CreatedUserId],[DateCreated] AS [CreatedDate],Convert(int,right(resumeid,7)) AS [UpdatedUserId],[LastUpdated] AS [UpdatedDate]FROM Forest.dbo.cv_certification
SELECT TOP 5 * FROM Forest.dbo.cv_certification
select top 5 * from srv_lnk.nchr2008.dbo.ResumeCertificate
